﻿CREATE TABLE [sacm].[CatPaciente] (
    [IdPaciente]      INT            IDENTITY (1, 1) NOT NULL,
    [ApellidoPaterno] NVARCHAR (250) NULL,
    [ApellidoMaterno] NVARCHAR (250) NULL,
    [Nombre]          NVARCHAR (250) NULL,
    [IdSexo]          INT            NULL,
    [FechaNacimiento] DATE           NULL,
    [IdEstado]        INT            NULL,
    [IdMunicipio]     INT            NULL,
    [IdColonia]       INT            NULL,
    [CodigoPostal]    INT            NULL,
    [Calle]           VARCHAR (500)  NULL,
    [NumExterio]      VARCHAR (10)   NULL,
    [NumInterio]      VARCHAR (10)   NULL,
    [Telefono]        VARCHAR (20)   NULL,
    [TelOficina]      VARCHAR (20)   NULL,
    [Celular]         VARCHAR (20)   NULL,
    [IdEstadoCivil]   INT            NULL,
    [IdProcedencia]   INT            NULL,
    [FechaMod]        DATETIME       NULL,
    [IpMod]           VARCHAR (15)   NULL,
    [IdUsuarioMod]    INT            NULL,
    [IdEmpresa]       INT            NOT NULL,
    [IdSucursal]      INT            NOT NULL
);



